Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1871

R_1871

HospitalizationType

HospitalizationTypeText

HospitalizationTypeID

 

 

R_1872

R_1872

HospitalizationType

Episode

HospitalizationTypeID

 

 

R_1873

R_1873

HospitalizationMode

Episode

HospitalizationModeID

 

 

R_1900

R_1900

HospitalizationMode

ContractService

HospitalizationModeID

 

 

R_1901

R_1901

ContractService

LContractServDRGParameters

ContractServID

 

 

R_1902

R_1902

DRGParameters

LContractServDRGParameters

DRGParametersID

 

 

R_1963

R_1963

ContractServiceRestriction

ContractService

ContractServiceRestrictionID

 

 

R_1980

R_1980

ContractService

ContractServMonthlyRestriction

ContractServID

 

 

R_1981

R_1981

Sex

ContractServiceRestriction

Sex

 

 

R_8170

R_8170

Personnel

LEventPersonnel

PersonID

 

 

R_8171

R_8171

PersonnelFunction

LEventPersonnel

PersonnelFunctionID

 

 

R_8172

R_8172

Event

LEventPersonnel

EventID

 

 

R_8700

R_8700

EpisodePriority

EpisodePriorityText

EpisodePriorityID

 

 

R_8701

R_8701

Episode

LEpisodePriority

EpisodeID

 

 

R_8702

R_8702

EpisodePriority

LEpisodePriority

EpisodePriorityID

 

 

R_8836

R_8836

DictionaryValue

Absence

AbsenceReasonID

 

 

R_8837

R_8837

Absence

LAbsenceEvent

AbsenceID

 

 

R_8838

R_8838

Event

LAbsenceEvent

EventID

 

 

R_8844

R_8844

Episode

ProsectoriumEpisode

EpisodeID

 

 

R_8845

R_8845

UserDefinition

ProsectoriumEpisode

InsertingPerson

 

 

R_8846

R_8846

UserDefinition

ProsectoriumEpisode

LastModifiedPerson

 

 

R_8860

R_8860

Absence

LAbsencePerfService

AbsenceID

 

 

R_8861

R_8861

PerfService

LAbsencePerfService

PerfServiceID

 

 

R_8995

R_8995

Episode

PatientPermission

EpisodeID

 

 

R_8996

R_8996

Event

PatientPermission

EventID

 

 

R_8997

R_8997

PerfService

PatientPermission

PerfServiceID

 

 

R_8998

R_8998

PermissionKind

PatientPermission

PermissionKindID

 

 

R_8999

R_8999

UserDefinition

PatientPermission

InsertingPerson

 

 

R_9000

R_9000

UserDefinition

PatientPermission

LastModifiedPerson

 

 

R_9093

R_9093

Event

Episode

WardAdmissionEventID

 

 

R_9310

R_9310

Event

Referral

SourceEventID

 

 

R_9476

R_9476

EpisodePriority

LOrgUnitPriorityWaitTime

EpisodePriorityID

 

 

R_10150

R_10150

Patient

PatientPermission

PersonID

 

 


1  2